String Functions – UPPER()

I am going to continue my series of very short articles or tidbits on Transaction SQL string functions. I will exploring the UPPER() function today. The UPPER() function takes a source string as input and returns a output string with all alpha characters converted to upper case. The following example converts the favorite movie title of mine to upper case. [crayon-664a1c06c50b7370475426/] [crayon-664a1c06c50bf396443490/] One thing to always worry about when using TSQL functions is how will it react with empty strings or NULL values? Both empty strings and NULL values as … Continue reading String Functions – UPPER()